Create table AutoPart.AutoPartInfo
(
AutoAccessory_InfoID int not null,
AutoPartVariationData_InfoID INT NOT NULL,
ModelYear int ,
Season nvarchar(50),
AutoPartColorSpecificationInfo_InfoID INT  ,
Diameter_LengthDimension_InfoID int ,
ItemPackageQuantity int default 1,
ItemShape NVARCHAR(50),
Material nvarchar(50) ,
Size nvarchar(50),
Voltage int,
Wattage INT,
NumberOfGrooves int,
NumberOfHoles int ,
ManufacturerWarrantyDescription nvarchar(50),
Position nvarchar(20),
Orientation nvarchar(20),
Profile nvarchar(10),
PulleyType nvarchar(15),
AutoPartPartInterchangeData_InfoID int ,
IsDel bit default 0,
CreateUser nvarchar(20) default 'PU',
CreateTime DATETIME DEFAULT GETDATE(),
UpdateUser nvarchar(20) default 'FL',
UpdateTime datetime default getdate()
)

Create TABLE AutoPart.AutoPartPartInterchangeDataInfo
(
AutoPartPartInterchangeData_InfoID int identity(1,1) primary key,
OEManufacturer nvarchar(50) not null,
PartInterchangeInfo nvarchar(50) not null,
IsDel bit default 0,
CreateUser nvarchar(20) default 'PU',
CreateTime DATETIME DEFAULT GETDATE(),
UpdateUser nvarchar(20) default 'FL',
UpdateTime datetime default getdate()
)

Create table AutoPart.AutoPartColorSpecificationInfo
(
AutoPartColorSpecificationInfo_InfoID INT IDENTITY(1,1) PRIMARY KEY,
Color nvarchar(50),
ColorMap nvarchar(50),
IsDel bit default 0,
CreateUser nvarchar(20) default 'PU',
CreateTime DATETIME DEFAULT GETDATE(),
UpdateUser nvarchar(20) default 'FL',
UpdateTime datetime default getdate()
)

Create table AutoPart.AutoPartVariationDataInfo
(
AutoPartVariationData_InfoID int identity(1,1) primary key,
Parentage nvarchar(6) not null,
VariationTheme nvarchar(10) not null,
IsDel bit default 0,
CreateUser nvarchar(20) default 'PU',
CreateTime datetime default getdate(),
UpdateUser nvarchar(20) default 'FL',
UpdateTime datetime default getdate()
)